if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_NganhHang_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_NganhHang_Insert]
GO
CREATE PROC [sp_NganhHang_Insert]
	@ten	nvarchar(100),
	@Ghi_Chu	nvarchar(500)
AS
BEGIN
	INSERT INTO NganhHang(Ten,Ghi_chu)
		VALUES(
			@ten,
			@Ghi_Chu
		)
END